{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["chisq grapher"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"chisq grapher","index":0,"n_rows":133,"n_cols":22,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
["Chi-squared grapher.",null,null,null,null,null,null,null,"PDF",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Play with the green cells!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"divide the scrollbar value above by max possible:"]
[null,"degrees of freedom:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V1/32767","v":0}]
[null,{"$f":"V5","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"multiply by max desired DOF, and add 1."]
[null,"maximum x value to go to: 1% significance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+V3*60","v":1}]
[null,{"$f":"CHIINV(0.01,dof)","v":6.634896711777805}]
[null,"# steps to take",null,null,null,"significance level (alpha)"]
[null,120,null,null,null,0.05]
[null,"dx per step",null,null,null,{"$f":"CHIINV(F8,dof)","v":3.841459149489757}]
[null,{"$f":"B6/B8","v":5.529080593148171E-2}]
[]
[null,"auto-zooming graph:",null,null,"fixed-zoom graph:"]
[null,"x","PDF","CDF","x","PDF","CDF",null,"x","y"]
[1,0,{"$f":"B14^(dof/2-1)*EXP(-B14/2)/(2^(dof/2) * EXP(GAMMALN(dof/2)))","v":{"$error":"#DIV/0!"}},{"$f":"1-CHIDIST(B14,dof)","v":0},0,{"$f":"E14^(dof/2-1)*EXP(-E14/2)/(2^(dof/2) * EXP(GAMMALN(dof/2)))","v":{"$error":"#DIV/0!"}},{"$f":"1-CHIDIST(E14,dof)","v":0},null,{"$f":"F9","v":3.841459149489757},0]
[2,{"$f":"B14+$B$10","v":5.529080593148171E-2},1.6503549482235293,0.18589990402368439,0.2,0.80717112930531421,{"$f":"1-CHIDIST(E15,dof)","v":0.34527915380404872},null,{"$f":"I14","v":3.841459149489757},1]
[3,{"$f":"B15+$B$10","v":0.11058161186296342},1.135157481657243,0.26051705142009984,0.4,0.51644154743377313,0.47291074276181222]
[4,0.16587241779444512,0.90157994043818002,0.3161935198694581,0.6,0.38154528935933951,0.56142196732910066]
[5,0.22116322372592684,0.75950148285083097,0.36184497360815693,0.8,0.29898353989880788,0.62890662800551389,null,"title"]
[6,0.27645402965740856,0.66079595169276417,0.40096515223440432,1,0.24197072450344506,0.68268918690237057,null,{"$f":"\"Chi-squared, dof=\"&dof","v":"Chi-squared, dof=1"}]
[7,0.33174483558889029,0.58677351724770233,0.43536653241283108,1.2,0.19986776388876648,0.72667810554328627]
[8,0.38703564152037201,0.52843413517440441,0.46613827513493122,1.4,0.16743255733422102,0.76327626756273537]
[9,0.44232644745185373,0.4808267760523286,0.49399828886478103,1.6,0.14171456529702992,0.79409667878193313]
[10,0.49761725338333546,0.44096704797106917,0.51945104278659338,1.8,0.12089512246536158,0.82028741333207744]
[11,0.55290805931481712,0.40693134703322431,0.5428681050916393,2,0.10377687434841595,0.84270073517455524]
[12,0.60819886524629885,0.37741447919252791,0.56453322345750367,2.2000000000000002,8.9531280367334404E-2,0.86198922218747753]
[13,0.66348967117778057,0.35149409313684682,0.5846693446782395,2.4,7.7562369235227566E-2,0.87866471880855401]
[14,0.71878047710926229,0.32849648889603739,0.60345577263040195,2.6,6.7428044588857039E-2,0.89313625913216921]
[15,0.77407128304074402,0.30791592056655587,0.62103949042237294,2.8,5.8792073248730238E-2,0.90573566943804529]
[16,0.82936208897222574,0.28936385840397977,0.63754294420604019,3,5.1393443264588848E-2,0.91673545960981906]
[17,0.88465289490370747,0.27253587540196667,0.65306954641776027,3.2,4.5026055837270929E-2,0.92636171691386771]
[18,0.93994370083518919,0.25718933980860842,0.66770767018431565,3.4,3.9524827940381417E-2,0.93480356620640348]
[19,0.99523450676667091,0.24312797104374906,0.68153362736579148,3.6,3.4755916724883498E-2,0.94222042038019216]
[20,1.0505253126981526,0.23019088993256712,0.69461359800054467,3.8,3.0609677353600689E-2,0.9487474062534722]
[21,1.1058161186296342,0.2182446913623228,0.70700652285563637,4,2.6995483254842648E-2,0.95449972950730899]
[22,1.1611069245611159,0.20717759778018202,0.71876369775333604,4.2,2.3837845935680477E-2,0.9595760166197097]
[23,1.2163977304925975,0.19689507545284049,0.72993104716810131,4.4000000000000004,2.1073460977662998E-2,0.96406106339784303]
[24,1.2716885364240791,0.18731649834174535,0.74054966569972236,4.5999999999999996,1.8648926683759309E-2,0.96802803997356945]
[25,1.3269793423555607,0.17837257495699968,0.75065651318007243,4.8,1.6518959581073831E-2,0.97154026060386611]
[26,1.3822701482870423,0.17000333938239745,0.76028503514326784,5,1.4644982560976367E-2,0.97465267971107916]
[27,1.4375609542185239,0.16215656526007791,0.76946543073432971,5.2,1.2993996367664989E-2,0.97741310897311495]
[28,1.4928517601500055,0.15478650088743823,0.7782253445489804,5.4,1.1537669245965311E-2,0.97986324652433943]
[29,1.5481425660814871,0.14785285093535175,0.78659004187729931,5.6,1.0251596472205658E-2,0.98203952117026405]
[30,1.6034333720129688,0.14131994960107935,0.79458256173367015,5.8,9.1146935479663044E-3,0.98397382456364046]
[31,1.6587241779444504,0.13515608382431221,0.80222424769672729,6,8.1086955544141786E-3,0.98569411968854403]
[32,1.714014983875932,0.12933293521039474,0.80953463384458568,6.2,7.2177415530680347E-3,0.98722496739938603]
[33,1.7693057898074136,{"$f":"B46^(dof/2-1)*EXP(-B46/2)/(2^(dof/2) * EXP(GAMMALN(dof/2)))","v":0.12382511665347622},{"$f":"1-CHIDIST(B46,dof)","v":0.81653191372458445},6.4,6.428027657522678E-3,0.9885879626839128]
[34,1.8245965957388952,0.11860978510460701,0.82323281403634074,6.6,5.7275159559831649E-3,0.98980212256395017]
[35,1.8798874016703768,0.11366631601715134,0.82965299092597111,6.8,5.1056891602782968E-3,0.99088421227722612]
[36,1.9351782076018584,0.1089760280957843,0.83580688858290542,7,4.5533429213447671E-3,0.99184902806983088]
[37,1.99046901353334,0.10452194933851204,0.84170809126277102,7.2,4.0624093465097327E-3,0.99270964166641851]
[38,2.0457598194648217,0.10028861718154629,0.84736919125638588,7.4,3.6258064974180101E-3,0.99347761211880981]
[39,2.1010506253963035,9.6261906970352543E-2,0.85280197545271408,7.6,3.2373096245421197E-3,0.99416316943641558]
[40,2.1563414313277853,9.2428884085982696E-2,0.85801755646047773,7.8,2.8914406677477979E-3,0.99477537620403489]
[41,2.2116322372592672,8.8777675927012564E-2,0.86302628270268356,8,2.5833731690939055E-3,0.99532226475468633]
[42,2.266923043190749,8.5297360638390288E-2,0.86783788082530955,8.1999999999999993,2.3088502389725729E-3,0.99581096082977993]
[43,2.3222138491222308,8.1977870030018898E-2,0.87246156285615961,8.4,2.0641136163550536E-3,0.99624778975202133]
[44,2.3775046550537127,7.8809904570733086E-2,0.8769059357680109,8.6,1.8458421885179598E-3,0.99663836985833421]
[45,2.4327954609851945,7.57848587009297E-2,0.88117911719853281,8.8000000000000007,1.6510986007178732E-3,0.99698769446638313]
[46,2.4880862669166763,7.2894754997440123E-2,0.88528882931969477,9,1.4772828038834942E-3,0.99730020387427798]
[47,2.5433770728481582,7.0132185961157556E-2,0.88924230230956747,9.1999999999999993,1.3220915678729603E-3,0.99757984868114835]
[48,2.59866787877964,6.7490262392225775E-2,0.89304639524810681,9.4,1.1834831365501964E-3,0.99783014553710603]
[49,2.6539586847111218,6.4962567477672192E-2,0.89670759949925238,9.6,1.0596463246688905E-3,0.99805422627909801]
[50,2.7092494906426037,6.2543115848840952E-2,0.90023204934146683,9.8000000000000007,9.4897345992208174E-4,0.99825488119750438]
[51,2.7645402965740855,6.0226316976081259E-2,0.90362560451785379,10,8.500366601968865E-4,0.9984345976621487]
[52,2.8198311025055673,5.8006942360021116E-2,0.90689377770972457,10.199999999999999,7.6156700901935514E-4,0.9985955934004167]
[53,2.8751219084370492,5.5880096055725033E-2,0.91004181893562475,10.4,6.8243625376569696E-4,0.99873984681406902]
[54,2.930412714368531,5.3841188130756473E-2,0.91307471605647073,10.6,6.1164070338381321E-4,0.99886912336176992]
[55,2.9857035203000128,5.1885910712784492E-2,0.91599719924756995,10.8,5.4828704668593567E-4,0.99898499902341342]
[56,3.0409943262314947,5.0010216328626157E-2,0.91881380488393194,11,4.915798500257294E-4,0.99908888109976268]
[57,3.0962851321629765,4.8210298275914401E-2,0.92152881311701085,11.2,4.4081052541824339E-4,0.99918202666189415]
[58,3.1515759380944584,4.6482572802075052E-2,0.92414631372486511,11.4,3.9534758777046381E-4,0.99926555892597946]
[59,3.2068667440259402,4.4823662893933372E-2,0.92667020410477374,11.6,3.5462804358550988E-4,0.99934048179510193]
[60,3.262157549957422,4.3230383505826031E-2,0.92910420029285978,11.8,3.1814977388454845E-4,0.99940769278036246]
[61,3.3174483558889039,4.1699728075210073E-2,0.93145183782874974,12,2.8546479165733499E-4,0.9994679944878806]
[62,3.3727391618203857,4.022885619296903E-2,0.93371652007748529,13,1.6635055619206672E-4,0.99968850902103967]
[63,3.4280299677518675,3.8815082311358606E-2,0.9359014667644231,14,9.7226505039606632E-5,0.99981718936153141]
[64,3.4833207736833494,3.7455865386180537E-2,0.93800976405518244,15,5.6971259657731305E-5,0.99989248882129778]
[65,3.5386115796148312,{"$f":"B78^(dof/2-1)*EXP(-B78/2)/(2^(dof/2) * EXP(GAMMALN(dof/2)))","v":3.614879936163061E-2},{"$f":"1-CHIDIST(B78,dof)","v":0.94004436138262837},16,{"$f":"E78^(dof/2-1)*EXP(-E78/2)/(2^(dof/2) * EXP(GAMMALN(dof/2)))","v":3.3457556439050722E-5},0.99993665751560679]
[66,3.593902385546313,3.4891604416595584E-2,0.94200807866688829,17,1.9687134526232378E-5,{"$f":"1-CHIDIST(E79,dof)","v":0.99996262018132454}]
[67,{"$f":"B79+$B$10","v":3.6491931914777949},3.3682118900190891E-2,0.94390361307043114,18,1.1604420994809464E-5,0.99997790950289633]
[68,3.7044839974092767,3.2518291892221649E-2,0.94573354532456066,19,6.8507116343986476E-6,0.99998692815459223]
[69,3.7597748033407585,3.1398176331169002E-2,0.94750033913389353,20,4.0499554777818101E-6,0.99999225578355266]
[70,3.8150656092722404,3.0319922658384246E-2,0.94920637367561889,21,2.3972225726955155E-6,0.99999540716628177]
[71,3.8703564152037222,2.9281772932527664E-2,0.95085390707329565,22,1.4205594856822599E-6,0.99999727349530276]
[72,3.925647221135204,2.8282055373013662E-2,0.95244511013521982,24,5.0034626488439155E-7,0.99999903664298329]
[73,3.9809380270666859,2.731917929540004E-2,0.95398206349543457,26,1.7684595354403111E-7,0.99999965858264062]
[74,4.0362288329981677,2.6391630405358326E-2,0.95546676196662805,28,6.2691448362819958E-8,0.99999987868454887]
[75,4.0915196389296495,2.549796642114446E-2,0.95690111864193228,30,2.2280873343804147E-8,0.99999995679536935]
[76,4.1468104448611314,2.4636812997406114E-2,0.95828696876303709,32,7.9363966694017105E-9,0.99999998458274209]
[77,4.2021012507926132,2.3806859925761016E-2,0.9596260733706099,34,2.8324641052260428E-9,0.99999999448879273]
[78,4.257392056724095,2.3006857589896883E-2,0.96092012275170891,36,1.0126471415715169E-9,0.99999999802682471]
[79,4.3126828626555769,2.2235613655013548E-2,0.96217073542687559,38,3.6259608556378423E-10,0.99999999929255368]
[80,4.3679736685870587,2.1491989973279519E-2,0.96337947880565677,40,1.3001409343292478E-10,0.99999999974603715]
[81,4.4232644745185405,2.0774899688634527E-2,0.96454784494418822,42,4.6676824285528765E-11,0.99999999990872657]
[82,4.4785552804500224,2.0083304525759113E-2,0.96567727198784137,44,1.677664542036904E-11,0.99999999996716238]
[83,4.5338460863815042,1.9416212249370578E-2,0.96676914195718089,46,6.036122794668444E-12,0.99999999998817468]
[84,4.589136892312986,1.8772674281209687E-2,0.96782478322723664,48,2.173811497384911E-12,0.99999999999573785]
[85,4.6444276982444679,1.8151783463168147E-2,0.96884547287906853,50,7.8354332650003298E-13,0.99999999999846256]
[86,4.6997185041759497,1.7552671955987118E-2,0.96983243893141713,52,2.8265187093130348E-13,0.999999999999445]
[87,4.7550093101074316,1.6974509263842724E-2,0.9707868624596665,54,1.0203805565503771E-13,0.99999999999979949]
[88,4.8103001160389134,1.6416500375935922E-2,0.97170987960883615,56,3.6861292482874938E-14,0.9999999999999275]
[89,4.8655909219703952,1.5877884016930476E-2,0.97260258350684425,58,1.3324658702031901E-14,0.9999999999999738]
[90,4.9208817279018771,1.5357930998741406E-2,0.97346602608385602,60,4.8194777931841388E-15,0.99999999999999056]
[91,4.9761725338333589,1.4855942666774768E-2,0.97430121980312723,62,1.7441558222546223E-15,0.99999999999999656]
[92,5.0314633397648407,1.4371249434263716E-2,0.97510913679404188,64,6.3153388540113964E-16,0.99999999999999878]
[93,5.0867541456963226,1.3903209398840991E-2,0.97589072073753591,66,2.2878112709031351E-16,0.99999999999999956]
[94,5.1420449516278044,1.3451207035939786E-2,0.9766468724682954,68,8.2916932055533367E-17,0.99999999999999989]
[95,5.1973357575592862,1.3014651964026423E-2,0.97737846229311665,70,3.0064513405131548E-17,0.99999999999999989]
[96,5.2526265634907681,1.2592977777044923E-2,0.97808632854352362,72,1.0905421829497762E-17,1]
[97,5.3079173694222499,{"$f":"B110^(dof/2-1)*EXP(-B110/2)/(2^(dof/2) * EXP(GAMMALN(dof/2)))","v":1.2185640939797293E-2},{"$f":"1-CHIDIST(B110,dof)","v":0.97877127887065307},74,3.9572945368733248E-18,1]
[98,5.3632081753537317,1.1792119742298407E-2,0.9794340914807026,76,1.4365242354575639E-18,1]
[99,5.4184989812852136,1.1411913309432739E-2,0.98007551631409928,78,5.2164850878560389E-19,1]
[100,5.4737897872166954,1.1044540662504846E-2,0.98069627617135413,80,1.8948978200835573E-19,1]
[101,5.5290805931481772,1.06895398295185E-2,0.98129706778838366,82,6.8854032717583527E-20,1]
[102,5.5843713990796591,1.0346467001242279E-2,0.98187856286390973,84,2.502661904430774E-20,1]
[103,5.6396622050111409,1.0014895730325055E-2,0.98244140904139665,86,9.0990933025715917E-21,1]
[104,5.6949530109426227,9.694416170913522E-3,0.98298623084783177,88,3.3091124530701448E-21,1]
[105,5.7502438168741046,9.3846343563981117E-3,0.98351363059152541,90,1.203752287500431E-21,1]
[106,5.8055346228055864,9.085171513074277E-3,0.98402418922097623,92,4.3799583888248822E-22,1]
[107,5.8608254287370682,8.7956634076541921E-3,0.98451846714673041,94,1.5940630297538342E-22,1]
[108,5.9161162346685501,8.5157597267009229E-3,0.98499700502805232,96,5.8028229221322129E-23,1]
[109,5.9714070406000319,8.2451234861836281E-3,0.98546032452612264,98,2.1128439134354499E-23,1]
[110,6.0266978465315137,7.983430469469496E-3,0.98590892781571726,100,7.6945986262072192E-24,1]
[111,6.0819886524629956,7.7303686921764911E-3,0.98634330322516783,102,2.8027954438593851E-24,1]
[112,6.1372794583944774,7.4856378924115664E-3,0.98676391829922239,104,1.0211283578086033E-24,1]
[113,6.1925702643259593,7.2489490450121149E-3,0.9871712256250682,106,3.7209136557961593E-25,1]
[114,6.2478610702574411,7.0200238984949115E-3,0.98756566210921382,108,1.3561138931905265E-25,1]
[115,6.3031518761889229,6.7985945334972575E-3,0.9879476495608891,110,4.9433028538112582E-26,1]
[116,6.3584426821204048,6.5844029415695034E-3,0.98831759525159724,112,1.802229390714217E-26,1]
[117,6.4137334880518866,6.3772006232477516E-3,0.98867589245191412,114,6.57161589883826E-27,1]
[118,6.4690242939833684,6.1767482044000387E-3,0.9890229209465724,116,2.3966307144237965E-27,1]
[119,6.5243150999148503,5.9828150698996276E-3,0.98935904752881487,118,8.7416744705014994E-28,1]
[120,6.5796059058463321,5.7951790137349673E-3,0.98968462647495081,120,3.1889706968753537E-28,1]